using System; 
using System.Text; 
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration; 
using System.Xml; 
using System.Xml.Serialization;
using SubSonic; 
using SubSonic.Utilities;

namespace Adex{
    /// <summary>
    /// Strongly-typed collection for the VOrderDetail class.
    /// </summary>
    [Serializable]
    public partial class VOrderDetailCollection : ReadOnlyList<VOrderDetail, VOrderDetailCollection>
    {        
        public VOrderDetailCollection() {}

    }

    /// <summary>
    /// This is  Read-only wrapper class for the vOrderDetail view.
    /// </summary>
    [Serializable]
    public partial class VOrderDetail : ReadOnlyRecord<VOrderDetail> 
    {
    
	    #region Default Settings
	    protected static void SetSQLProps() 
	    {
		    GetTableSchema();
	    }

	    #endregion
        #region Schema Accessor
	    public static TableSchema.Table Schema
        {
            get
            {
                if (BaseSchema == null)
                {
                    SetSQLProps();
                }

                return BaseSchema;
            }

        }

    	
        private static void GetTableSchema() 
        {
            if(!IsSchemaInitialized)
            {
                //Schema declaration
                TableSchema.Table schema = new TableSchema.Table("vOrderDetail", TableType.View, DataService.GetInstance("Adex"));
                schema.Columns = new TableSchema.TableColumnCollection();
                schema.SchemaName = "dbo";
                //columns
                
                TableSchema.TableColumn colvarUserName = new TableSchema.TableColumn(schema);
                colvarUserName.ColumnName = "UserName";
                colvarUserName.DataType = DbType.String;
                colvarUserName.MaxLength = 50;
                colvarUserName.AutoIncrement = false;
                colvarUserName.IsNullable = true;
                colvarUserName.IsPrimaryKey = false;
                colvarUserName.IsForeignKey = false;
                colvarUserName.IsReadOnly = false;
                
                schema.Columns.Add(colvarUserName);
                
                TableSchema.TableColumn colvarCompanyCode = new TableSchema.TableColumn(schema);
                colvarCompanyCode.ColumnName = "CompanyCode";
                colvarCompanyCode.DataType = DbType.Int32;
                colvarCompanyCode.MaxLength = 0;
                colvarCompanyCode.AutoIncrement = false;
                colvarCompanyCode.IsNullable = true;
                colvarCompanyCode.IsPrimaryKey = false;
                colvarCompanyCode.IsForeignKey = false;
                colvarCompanyCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarCompanyCode);
                
                TableSchema.TableColumn colvarEmail = new TableSchema.TableColumn(schema);
                colvarEmail.ColumnName = "Email";
                colvarEmail.DataType = DbType.String;
                colvarEmail.MaxLength = 100;
                colvarEmail.AutoIncrement = false;
                colvarEmail.IsNullable = true;
                colvarEmail.IsPrimaryKey = false;
                colvarEmail.IsForeignKey = false;
                colvarEmail.IsReadOnly = false;
                
                schema.Columns.Add(colvarEmail);
                
                TableSchema.TableColumn colvarFullName = new TableSchema.TableColumn(schema);
                colvarFullName.ColumnName = "FullName";
                colvarFullName.DataType = DbType.String;
                colvarFullName.MaxLength = 100;
                colvarFullName.AutoIncrement = false;
                colvarFullName.IsNullable = true;
                colvarFullName.IsPrimaryKey = false;
                colvarFullName.IsForeignKey = false;
                colvarFullName.IsReadOnly = false;
                
                schema.Columns.Add(colvarFullName);
                
                TableSchema.TableColumn colvarSiteUserID = new TableSchema.TableColumn(schema);
                colvarSiteUserID.ColumnName = "SiteUserID";
                colvarSiteUserID.DataType = DbType.Int32;
                colvarSiteUserID.MaxLength = 0;
                colvarSiteUserID.AutoIncrement = false;
                colvarSiteUserID.IsNullable = false;
                colvarSiteUserID.IsPrimaryKey = false;
                colvarSiteUserID.IsForeignKey = false;
                colvarSiteUserID.IsReadOnly = false;
                
                schema.Columns.Add(colvarSiteUserID);
                
                TableSchema.TableColumn colvarOrderStatus = new TableSchema.TableColumn(schema);
                colvarOrderStatus.ColumnName = "OrderStatus";
                colvarOrderStatus.DataType = DbType.Byte;
                colvarOrderStatus.MaxLength = 0;
                colvarOrderStatus.AutoIncrement = false;
                colvarOrderStatus.IsNullable = true;
                colvarOrderStatus.IsPrimaryKey = false;
                colvarOrderStatus.IsForeignKey = false;
                colvarOrderStatus.IsReadOnly = false;
                
                schema.Columns.Add(colvarOrderStatus);
                
                TableSchema.TableColumn colvarOrderTotal = new TableSchema.TableColumn(schema);
                colvarOrderTotal.ColumnName = "OrderTotal";
                colvarOrderTotal.DataType = DbType.Currency;
                colvarOrderTotal.MaxLength = 0;
                colvarOrderTotal.AutoIncrement = false;
                colvarOrderTotal.IsNullable = false;
                colvarOrderTotal.IsPrimaryKey = false;
                colvarOrderTotal.IsForeignKey = false;
                colvarOrderTotal.IsReadOnly = false;
                
                schema.Columns.Add(colvarOrderTotal);
                
                TableSchema.TableColumn colvarOrderDate = new TableSchema.TableColumn(schema);
                colvarOrderDate.ColumnName = "OrderDate";
                colvarOrderDate.DataType = DbType.DateTime;
                colvarOrderDate.MaxLength = 0;
                colvarOrderDate.AutoIncrement = false;
                colvarOrderDate.IsNullable = false;
                colvarOrderDate.IsPrimaryKey = false;
                colvarOrderDate.IsForeignKey = false;
                colvarOrderDate.IsReadOnly = false;
                
                schema.Columns.Add(colvarOrderDate);
                
                TableSchema.TableColumn colvarOrderDetailID = new TableSchema.TableColumn(schema);
                colvarOrderDetailID.ColumnName = "OrderDetailID";
                colvarOrderDetailID.DataType = DbType.Int32;
                colvarOrderDetailID.MaxLength = 0;
                colvarOrderDetailID.AutoIncrement = false;
                colvarOrderDetailID.IsNullable = false;
                colvarOrderDetailID.IsPrimaryKey = false;
                colvarOrderDetailID.IsForeignKey = false;
                colvarOrderDetailID.IsReadOnly = false;
                
                schema.Columns.Add(colvarOrderDetailID);
                
                TableSchema.TableColumn colvarOrderID = new TableSchema.TableColumn(schema);
                colvarOrderID.ColumnName = "OrderID";
                colvarOrderID.DataType = DbType.Int32;
                colvarOrderID.MaxLength = 0;
                colvarOrderID.AutoIncrement = false;
                colvarOrderID.IsNullable = true;
                colvarOrderID.IsPrimaryKey = false;
                colvarOrderID.IsForeignKey = false;
                colvarOrderID.IsReadOnly = false;
                
                schema.Columns.Add(colvarOrderID);
                
                TableSchema.TableColumn colvarMediaType = new TableSchema.TableColumn(schema);
                colvarMediaType.ColumnName = "MediaTypeCode";
                colvarMediaType.DataType = DbType.Int32;
                colvarMediaType.MaxLength = 0;
                colvarMediaType.AutoIncrement = false;
                colvarMediaType.IsNullable = true;
                colvarMediaType.IsPrimaryKey = false;
                colvarMediaType.IsForeignKey = false;
                colvarMediaType.IsReadOnly = false;
                
                schema.Columns.Add(colvarMediaType);
                
                TableSchema.TableColumn colvarProductID = new TableSchema.TableColumn(schema);
                colvarProductID.ColumnName = "ProductID";
                colvarProductID.DataType = DbType.Int32;
                colvarProductID.MaxLength = 0;
                colvarProductID.AutoIncrement = false;
                colvarProductID.IsNullable = true;
                colvarProductID.IsPrimaryKey = false;
                colvarProductID.IsForeignKey = false;
                colvarProductID.IsReadOnly = false;
                
                schema.Columns.Add(colvarProductID);
                
                TableSchema.TableColumn colvarProductName = new TableSchema.TableColumn(schema);
                colvarProductName.ColumnName = "ProductName";
                colvarProductName.DataType = DbType.String;
                colvarProductName.MaxLength = 500;
                colvarProductName.AutoIncrement = false;
                colvarProductName.IsNullable = true;
                colvarProductName.IsPrimaryKey = false;
                colvarProductName.IsForeignKey = false;
                colvarProductName.IsReadOnly = false;
                
                schema.Columns.Add(colvarProductName);
                
                TableSchema.TableColumn colvarProdVersionID = new TableSchema.TableColumn(schema);
                colvarProdVersionID.ColumnName = "ProdVersionID";
                colvarProdVersionID.DataType = DbType.Int32;
                colvarProdVersionID.MaxLength = 0;
                colvarProdVersionID.AutoIncrement = false;
                colvarProdVersionID.IsNullable = true;
                colvarProdVersionID.IsPrimaryKey = false;
                colvarProdVersionID.IsForeignKey = false;
                colvarProdVersionID.IsReadOnly = false;
                
                schema.Columns.Add(colvarProdVersionID);
                
                TableSchema.TableColumn colvarProdVersionName = new TableSchema.TableColumn(schema);
                colvarProdVersionName.ColumnName = "ProdVersionName";
                colvarProdVersionName.DataType = DbType.String;
                colvarProdVersionName.MaxLength = 500;
                colvarProdVersionName.AutoIncrement = false;
                colvarProdVersionName.IsNullable = true;
                colvarProdVersionName.IsPrimaryKey = false;
                colvarProdVersionName.IsForeignKey = false;
                colvarProdVersionName.IsReadOnly = false;
                
                schema.Columns.Add(colvarProdVersionName);
                
                TableSchema.TableColumn colvarPrice = new TableSchema.TableColumn(schema);
                colvarPrice.ColumnName = "Price";
                colvarPrice.DataType = DbType.Currency;
                colvarPrice.MaxLength = 0;
                colvarPrice.AutoIncrement = false;
                colvarPrice.IsNullable = true;
                colvarPrice.IsPrimaryKey = false;
                colvarPrice.IsForeignKey = false;
                colvarPrice.IsReadOnly = false;
                
                schema.Columns.Add(colvarPrice);
                
                TableSchema.TableColumn colvarShortVideo = new TableSchema.TableColumn(schema);
                colvarShortVideo.ColumnName = "ShortVideo";
                colvarShortVideo.DataType = DbType.Boolean;
                colvarShortVideo.MaxLength = 0;
                colvarShortVideo.AutoIncrement = false;
                colvarShortVideo.IsNullable = false;
                colvarShortVideo.IsPrimaryKey = false;
                colvarShortVideo.IsForeignKey = false;
                colvarShortVideo.IsReadOnly = false;
                
                schema.Columns.Add(colvarShortVideo);
                
                TableSchema.TableColumn colvarShortVideoFile = new TableSchema.TableColumn(schema);
                colvarShortVideoFile.ColumnName = "ShortVideoFile";
                colvarShortVideoFile.DataType = DbType.String;
                colvarShortVideoFile.MaxLength = 50;
                colvarShortVideoFile.AutoIncrement = false;
                colvarShortVideoFile.IsNullable = true;
                colvarShortVideoFile.IsPrimaryKey = false;
                colvarShortVideoFile.IsForeignKey = false;
                colvarShortVideoFile.IsReadOnly = false;
                
                schema.Columns.Add(colvarShortVideoFile);
                
                TableSchema.TableColumn colvarFullVideo = new TableSchema.TableColumn(schema);
                colvarFullVideo.ColumnName = "FullVideo";
                colvarFullVideo.DataType = DbType.Boolean;
                colvarFullVideo.MaxLength = 0;
                colvarFullVideo.AutoIncrement = false;
                colvarFullVideo.IsNullable = false;
                colvarFullVideo.IsPrimaryKey = false;
                colvarFullVideo.IsForeignKey = false;
                colvarFullVideo.IsReadOnly = false;
                
                schema.Columns.Add(colvarFullVideo);
                
                TableSchema.TableColumn colvarFullVideoFile = new TableSchema.TableColumn(schema);
                colvarFullVideoFile.ColumnName = "FullVideoFile";
                colvarFullVideoFile.DataType = DbType.String;
                colvarFullVideoFile.MaxLength = 50;
                colvarFullVideoFile.AutoIncrement = false;
                colvarFullVideoFile.IsNullable = true;
                colvarFullVideoFile.IsPrimaryKey = false;
                colvarFullVideoFile.IsForeignKey = false;
                colvarFullVideoFile.IsReadOnly = false;
                
                schema.Columns.Add(colvarFullVideoFile);
                
                TableSchema.TableColumn colvarPressFile = new TableSchema.TableColumn(schema);
                colvarPressFile.ColumnName = "PressFile";
                colvarPressFile.DataType = DbType.String;
                colvarPressFile.MaxLength = 50;
                colvarPressFile.AutoIncrement = false;
                colvarPressFile.IsNullable = true;
                colvarPressFile.IsPrimaryKey = false;
                colvarPressFile.IsForeignKey = false;
                colvarPressFile.IsReadOnly = false;
                
                schema.Columns.Add(colvarPressFile);
                
                TableSchema.TableColumn colvarOutDoorFile = new TableSchema.TableColumn(schema);
                colvarOutDoorFile.ColumnName = "OutDoorFile";
                colvarOutDoorFile.DataType = DbType.String;
                colvarOutDoorFile.MaxLength = 50;
                colvarOutDoorFile.AutoIncrement = false;
                colvarOutDoorFile.IsNullable = true;
                colvarOutDoorFile.IsPrimaryKey = false;
                colvarOutDoorFile.IsForeignKey = false;
                colvarOutDoorFile.IsReadOnly = false;
                
                schema.Columns.Add(colvarOutDoorFile);
                
                TableSchema.TableColumn colvarDateAdded = new TableSchema.TableColumn(schema);
                colvarDateAdded.ColumnName = "DateAdded";
                colvarDateAdded.DataType = DbType.DateTime;
                colvarDateAdded.MaxLength = 0;
                colvarDateAdded.AutoIncrement = false;
                colvarDateAdded.IsNullable = false;
                colvarDateAdded.IsPrimaryKey = false;
                colvarDateAdded.IsForeignKey = false;
                colvarDateAdded.IsReadOnly = false;
                
                schema.Columns.Add(colvarDateAdded);
                
                TableSchema.TableColumn colvarDateModified = new TableSchema.TableColumn(schema);
                colvarDateModified.ColumnName = "DateModified";
                colvarDateModified.DataType = DbType.DateTime;
                colvarDateModified.MaxLength = 0;
                colvarDateModified.AutoIncrement = false;
                colvarDateModified.IsNullable = false;
                colvarDateModified.IsPrimaryKey = false;
                colvarDateModified.IsForeignKey = false;
                colvarDateModified.IsReadOnly = false;
                
                schema.Columns.Add(colvarDateModified);
                
                TableSchema.TableColumn colvarCompanyName = new TableSchema.TableColumn(schema);
                colvarCompanyName.ColumnName = "CompanyName";
                colvarCompanyName.DataType = DbType.String;
                colvarCompanyName.MaxLength = 255;
                colvarCompanyName.AutoIncrement = false;
                colvarCompanyName.IsNullable = true;
                colvarCompanyName.IsPrimaryKey = false;
                colvarCompanyName.IsForeignKey = false;
                colvarCompanyName.IsReadOnly = false;
                
                schema.Columns.Add(colvarCompanyName);
                
                TableSchema.TableColumn colvarRadioFile = new TableSchema.TableColumn(schema);
                colvarRadioFile.ColumnName = "RadioFile";
                colvarRadioFile.DataType = DbType.String;
                colvarRadioFile.MaxLength = 50;
                colvarRadioFile.AutoIncrement = false;
                colvarRadioFile.IsNullable = true;
                colvarRadioFile.IsPrimaryKey = false;
                colvarRadioFile.IsForeignKey = false;
                colvarRadioFile.IsReadOnly = false;
                
                schema.Columns.Add(colvarRadioFile);
                
                TableSchema.TableColumn colvarCableFile = new TableSchema.TableColumn(schema);
                colvarCableFile.ColumnName = "CableFile";
                colvarCableFile.DataType = DbType.String;
                colvarCableFile.MaxLength = 50;
                colvarCableFile.AutoIncrement = false;
                colvarCableFile.IsNullable = true;
                colvarCableFile.IsPrimaryKey = false;
                colvarCableFile.IsForeignKey = false;
                colvarCableFile.IsReadOnly = false;
                
                schema.Columns.Add(colvarCableFile);
                
                TableSchema.TableColumn colvarMediaTypeName = new TableSchema.TableColumn(schema);
                colvarMediaTypeName.ColumnName = "MediaTypeName";
                colvarMediaTypeName.DataType = DbType.String;
                colvarMediaTypeName.MaxLength = 50;
                colvarMediaTypeName.AutoIncrement = false;
                colvarMediaTypeName.IsNullable = true;
                colvarMediaTypeName.IsPrimaryKey = false;
                colvarMediaTypeName.IsForeignKey = false;
                colvarMediaTypeName.IsReadOnly = false;
                
                schema.Columns.Add(colvarMediaTypeName);
                
                TableSchema.TableColumn colvarInternetFile = new TableSchema.TableColumn(schema);
                colvarInternetFile.ColumnName = "InternetFile";
                colvarInternetFile.DataType = DbType.String;
                colvarInternetFile.MaxLength = 50;
                colvarInternetFile.AutoIncrement = false;
                colvarInternetFile.IsNullable = true;
                colvarInternetFile.IsPrimaryKey = false;
                colvarInternetFile.IsForeignKey = false;
                colvarInternetFile.IsReadOnly = false;
                
                schema.Columns.Add(colvarInternetFile);
                
                
                BaseSchema = schema;
                //add this schema to the provider
                //so we can query it later
                DataService.Providers["Adex"].AddSchema("vOrderDetail",schema);
            }

        }

        #endregion
        
        #region Query Accessor
	    public static Query CreateQuery()
	    {
		    return new Query(Schema);
	    }

	    #endregion
	    
	    #region .ctors
	    public VOrderDetail()
	    {
            SetSQLProps();
            SetDefaults();
            MarkNew();
        }

        public VOrderDetail(bool useDatabaseDefaults)
	    {
		    SetSQLProps();
		    if(useDatabaseDefaults)
		    {
				ForceDefaults();
			}

			MarkNew();
	    }

	    
	    public VOrderDetail(object keyID)
	    {
		    SetSQLProps();
		    LoadByKey(keyID);
	    }

    	 
	    public VOrderDetail(string columnName, object columnValue)
        {
            SetSQLProps();
            LoadByParam(columnName,columnValue);
        }

        
	    #endregion
	    
	    #region Props
	    
          
        [XmlAttribute("UserName")]
        public string UserName 
	    {
		    get
		    {
			    return GetColumnValue<string>("UserName");
		    }

            set 
		    {
			    SetColumnValue("UserName", value);
            }

        }

	      
        [XmlAttribute("CompanyCode")]
        public int? CompanyCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("CompanyCode");
		    }

            set 
		    {
			    SetColumnValue("CompanyCode", value);
            }

        }

	      
        [XmlAttribute("Email")]
        public string Email 
	    {
		    get
		    {
			    return GetColumnValue<string>("Email");
		    }

            set 
		    {
			    SetColumnValue("Email", value);
            }

        }

	      
        [XmlAttribute("FullName")]
        public string FullName 
	    {
		    get
		    {
			    return GetColumnValue<string>("FullName");
		    }

            set 
		    {
			    SetColumnValue("FullName", value);
            }

        }

	      
        [XmlAttribute("SiteUserID")]
        public int SiteUserID 
	    {
		    get
		    {
			    return GetColumnValue<int>("SiteUserID");
		    }

            set 
		    {
			    SetColumnValue("SiteUserID", value);
            }

        }

	      
        [XmlAttribute("OrderStatus")]
        public byte? OrderStatus 
	    {
		    get
		    {
			    return GetColumnValue<byte?>("OrderStatus");
		    }

            set 
		    {
			    SetColumnValue("OrderStatus", value);
            }

        }

	      
        [XmlAttribute("OrderTotal")]
        public decimal OrderTotal 
	    {
		    get
		    {
			    return GetColumnValue<decimal>("OrderTotal");
		    }

            set 
		    {
			    SetColumnValue("OrderTotal", value);
            }

        }

	      
        [XmlAttribute("OrderDate")]
        public DateTime OrderDate 
	    {
		    get
		    {
			    return GetColumnValue<DateTime>("OrderDate");
		    }

            set 
		    {
			    SetColumnValue("OrderDate", value);
            }

        }

	      
        [XmlAttribute("OrderDetailID")]
        public int OrderDetailID 
	    {
		    get
		    {
			    return GetColumnValue<int>("OrderDetailID");
		    }

            set 
		    {
			    SetColumnValue("OrderDetailID", value);
            }

        }

	      
        [XmlAttribute("OrderID")]
        public int? OrderID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("OrderID");
		    }

            set 
		    {
			    SetColumnValue("OrderID", value);
            }

        }

	      
        [XmlAttribute("MediaType")]
        public int? MediaType 
	    {
		    get
		    {
			    return GetColumnValue<int?>("MediaTypeCode");
		    }

            set 
		    {
			    SetColumnValue("MediaTypeCode", value);
            }

        }

	      
        [XmlAttribute("ProductID")]
        public int? ProductID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("ProductID");
		    }

            set 
		    {
			    SetColumnValue("ProductID", value);
            }

        }

	      
        [XmlAttribute("ProductName")]
        public string ProductName 
	    {
		    get
		    {
			    return GetColumnValue<string>("ProductName");
		    }

            set 
		    {
			    SetColumnValue("ProductName", value);
            }

        }

	      
        [XmlAttribute("ProdVersionID")]
        public int? ProdVersionID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("ProdVersionID");
		    }

            set 
		    {
			    SetColumnValue("ProdVersionID", value);
            }

        }

	      
        [XmlAttribute("ProdVersionName")]
        public string ProdVersionName 
	    {
		    get
		    {
			    return GetColumnValue<string>("ProdVersionName");
		    }

            set 
		    {
			    SetColumnValue("ProdVersionName", value);
            }

        }

	      
        [XmlAttribute("Price")]
        public decimal? Price 
	    {
		    get
		    {
			    return GetColumnValue<decimal?>("Price");
		    }

            set 
		    {
			    SetColumnValue("Price", value);
            }

        }

	      
        [XmlAttribute("ShortVideo")]
        public bool ShortVideo 
	    {
		    get
		    {
			    return GetColumnValue<bool>("ShortVideo");
		    }

            set 
		    {
			    SetColumnValue("ShortVideo", value);
            }

        }

	      
        [XmlAttribute("ShortVideoFile")]
        public string ShortVideoFile 
	    {
		    get
		    {
			    return GetColumnValue<string>("ShortVideoFile");
		    }

            set 
		    {
			    SetColumnValue("ShortVideoFile", value);
            }

        }

	      
        [XmlAttribute("FullVideo")]
        public bool FullVideo 
	    {
		    get
		    {
			    return GetColumnValue<bool>("FullVideo");
		    }

            set 
		    {
			    SetColumnValue("FullVideo", value);
            }

        }

	      
        [XmlAttribute("FullVideoFile")]
        public string FullVideoFile 
	    {
		    get
		    {
			    return GetColumnValue<string>("FullVideoFile");
		    }

            set 
		    {
			    SetColumnValue("FullVideoFile", value);
            }

        }

	      
        [XmlAttribute("PressFile")]
        public string PressFile 
	    {
		    get
		    {
			    return GetColumnValue<string>("PressFile");
		    }

            set 
		    {
			    SetColumnValue("PressFile", value);
            }

        }

	      
        [XmlAttribute("OutDoorFile")]
        public string OutDoorFile 
	    {
		    get
		    {
			    return GetColumnValue<string>("OutDoorFile");
		    }

            set 
		    {
			    SetColumnValue("OutDoorFile", value);
            }

        }

	      
        [XmlAttribute("DateAdded")]
        public DateTime DateAdded 
	    {
		    get
		    {
			    return GetColumnValue<DateTime>("DateAdded");
		    }

            set 
		    {
			    SetColumnValue("DateAdded", value);
            }

        }

	      
        [XmlAttribute("DateModified")]
        public DateTime DateModified 
	    {
		    get
		    {
			    return GetColumnValue<DateTime>("DateModified");
		    }

            set 
		    {
			    SetColumnValue("DateModified", value);
            }

        }

	      
        [XmlAttribute("CompanyName")]
        public string CompanyName 
	    {
		    get
		    {
			    return GetColumnValue<string>("CompanyName");
		    }

            set 
		    {
			    SetColumnValue("CompanyName", value);
            }

        }

	      
        [XmlAttribute("RadioFile")]
        public string RadioFile 
	    {
		    get
		    {
			    return GetColumnValue<string>("RadioFile");
		    }

            set 
		    {
			    SetColumnValue("RadioFile", value);
            }

        }

	      
        [XmlAttribute("CableFile")]
        public string CableFile 
	    {
		    get
		    {
			    return GetColumnValue<string>("CableFile");
		    }

            set 
		    {
			    SetColumnValue("CableFile", value);
            }

        }

	      
        [XmlAttribute("MediaTypeName")]
        public string MediaTypeName 
	    {
		    get
		    {
			    return GetColumnValue<string>("MediaTypeName");
		    }

            set 
		    {
			    SetColumnValue("MediaTypeName", value);
            }

        }

	      
        [XmlAttribute("InternetFile")]
        public string InternetFile 
	    {
		    get
		    {
			    return GetColumnValue<string>("InternetFile");
		    }

            set 
		    {
			    SetColumnValue("InternetFile", value);
            }

        }

	    
	    #endregion
    
	    #region Columns Struct
	    public struct Columns
	    {
		    
		    
            public static string UserName = @"UserName";
            
            public static string CompanyCode = @"CompanyCode";
            
            public static string Email = @"Email";
            
            public static string FullName = @"FullName";
            
            public static string SiteUserID = @"SiteUserID";
            
            public static string OrderStatus = @"OrderStatus";
            
            public static string OrderTotal = @"OrderTotal";
            
            public static string OrderDate = @"OrderDate";
            
            public static string OrderDetailID = @"OrderDetailID";
            
            public static string OrderID = @"OrderID";
            
            public static string MediaType = @"MediaTypeCode";
            
            public static string ProductID = @"ProductID";
            
            public static string ProductName = @"ProductName";
            
            public static string ProdVersionID = @"ProdVersionID";
            
            public static string ProdVersionName = @"ProdVersionName";
            
            public static string Price = @"Price";
            
            public static string ShortVideo = @"ShortVideo";
            
            public static string ShortVideoFile = @"ShortVideoFile";
            
            public static string FullVideo = @"FullVideo";
            
            public static string FullVideoFile = @"FullVideoFile";
            
            public static string PressFile = @"PressFile";
            
            public static string OutDoorFile = @"OutDoorFile";
            
            public static string DateAdded = @"DateAdded";
            
            public static string DateModified = @"DateModified";
            
            public static string CompanyName = @"CompanyName";
            
            public static string RadioFile = @"RadioFile";
            
            public static string CableFile = @"CableFile";
            
            public static string MediaTypeName = @"MediaTypeName";
            
            public static string InternetFile = @"InternetFile";
            
	    }

	    #endregion
    }

}

